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