UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTHdpjcpDT7LulAZUm96piypisxFBm4qj9pp8bQluE0='
WHERE
key_id = '492c29ad6ed299c19e2ee54769a52ea155bede4f05562fba83dc90b64cb00e05'
AND (
token = 'tTHdpjcpDT7LulAZUm96piypisxFBm4qj9pp8bQluE0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)