UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHywW3fhNnOumcXmE4ohYkXpYTVoIeFStxt4rpkhGAU='
WHERE
key_id = 'c5ea8df8f3f70ba9ab430ecb1646c54136c420c8b68050894fcf044db01d1b9a'
AND (
token = 'HHywW3fhNnOumcXmE4ohYkXpYTVoIeFStxt4rpkhGAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)