UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIYzVlyTdf6BPtfs4DJOxuhtTDLleBPG3/fix1CCmH0='
WHERE
key_id = 'd3fcaf97300bfd1845e709c8e2a3a296c35b6b95861d337cd16772fa446af603'
AND (
token = 'sIYzVlyTdf6BPtfs4DJOxuhtTDLleBPG3/fix1CCmH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)