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