UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gyCDyjePIgf9rahNfS1LLBaTnzOFfNPksDhIIP6XYBU='
WHERE
key_id = 'db3e890c5ca6eaf8a32ba4715a6b14b1a2bb2937636214d481bc0755633207bd'
AND (
token = 'gyCDyjePIgf9rahNfS1LLBaTnzOFfNPksDhIIP6XYBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)