UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gca2UFJmsVRdxQNBhXd9LdxVaithq8jhq3/Nc3JUiWE='
WHERE
key_id = 'f7e9b9fcc3d217d8dc95145b8a6894666610ce0d9180a37078c7f9d41f1a1500'
AND (
token = 'Gca2UFJmsVRdxQNBhXd9LdxVaithq8jhq3/Nc3JUiWE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)