UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kz4v8WESVfVACiyB738HLGSKPyHjOv17a0/diRfOM3Q='
WHERE
key_id = 'ecaabc974b099025eb624e2f0c5a42ba77fec1c1bb66d7138ec5005673f5d8c1'
AND (
token = 'kz4v8WESVfVACiyB738HLGSKPyHjOv17a0/diRfOM3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)