UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LX3Z/5pYc9NtDi8qlALNhummOL0iIx7xEhydB8CYzlI='
WHERE
key_id = 'b5239327dcc2aae687115640706c5be9a5a11bc883c056992bf81d14b65dfd2a'
AND (
token = 'LX3Z/5pYc9NtDi8qlALNhummOL0iIx7xEhydB8CYzlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)