UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyeaD9hqERFUBHprlJUccSIeRTacc3JRFsZspTk5CgY='
WHERE
key_id = '0dbcd919866192e3aa29c83b201dea341257710fdaf70b40a7fab8b394e64eb6'
AND (
token = 'ZyeaD9hqERFUBHprlJUccSIeRTacc3JRFsZspTk5CgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)