UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ve0YzDUDrgE7Lc306ksEKYO/4955puiYC5L4vEDvhc4='
WHERE
key_id = 'b57b8d12e08e062c4fe6511f0c7c5121ba62daf3a05e52e4b2931596664a84b3'
AND (
token = 'Ve0YzDUDrgE7Lc306ksEKYO/4955puiYC5L4vEDvhc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)