UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SY6a50GCp8fmIFhDCAChexbsfQ1Rw5h3dKvNMC4Z5go='
WHERE
key_id = '1aea5711947dc4867c10605e501264b645fad2118cd1b40b034d8477df8ad2cb'
AND (
token = 'SY6a50GCp8fmIFhDCAChexbsfQ1Rw5h3dKvNMC4Z5go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)