UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7yawIVmn0yhutogLl5THdNw3YRz5dowlMaoAPWKuFw='
WHERE
key_id = '9d1e4ced3ce17c7bcc1d526340f24eb777456fd01cbd47b3d7c5ab824cb1ea9e'
AND (
token = 'd7yawIVmn0yhutogLl5THdNw3YRz5dowlMaoAPWKuFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)