UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G1ZLj3jHiqObaEQXzfISN4usAfE8/a5UyHkd0ja6UKA='
WHERE
key_id = '187022476d6b65cbd4f5a567b14ecb2f104fcd7f66734cf9e7be8df2527cf2f1'
AND (
token = 'G1ZLj3jHiqObaEQXzfISN4usAfE8/a5UyHkd0ja6UKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)