UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'otys8dsowg7CSXAqFf4vvoW69/mAVLDVjOlIy4PJvLw='
WHERE
key_id = '44b735e739554bdff983a3852e0cfe10c98ed2b48b85161603a06c5ae10a94a7'
AND (
token = 'otys8dsowg7CSXAqFf4vvoW69/mAVLDVjOlIy4PJvLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)