UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OVYeUyyJhRM8JkhfEiTK9Q4ZR3915E9/58sLHun3wg='
WHERE
key_id = 'a385fb6ba47639628064160dec65147652f8c0af7a2eadf8bd43d0468d1340cb'
AND (
token = '1OVYeUyyJhRM8JkhfEiTK9Q4ZR3915E9/58sLHun3wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)