UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VN//ZjHvYeus2rETnpOoR5cxX893jlCBBeq7id5oJYc='
WHERE
key_id = 'dc89981c8512b2979967d5555fd4a7876e93c39df8bfa99975025342eae5d7e9'
AND (
token = 'VN//ZjHvYeus2rETnpOoR5cxX893jlCBBeq7id5oJYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)