UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zG1eAuKq+/HU41fmH8fZb2GYbsA6/FbTvQinBE5C8Qc='
WHERE
key_id = '23ceb8fa84bce5aec9de16348214f43c04bfd11af0194ee6fc1396a67195432d'
AND (
token = 'zG1eAuKq+/HU41fmH8fZb2GYbsA6/FbTvQinBE5C8Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)