UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q5WgUTZX5tYmI5PLadwU6WagR6NtW+Lkyv+7pJjtqgE='
WHERE
key_id = '5b867270ca736a3c32bcf3141f340fafedbd30a691cc127e4e825db831532600'
AND (
token = 'q5WgUTZX5tYmI5PLadwU6WagR6NtW+Lkyv+7pJjtqgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)