UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZL6HK9DX+e1C4BHVW1gn8tnVjyktS4bhvy7a9UoJMR0='
WHERE
key_id = 'b92b427682d0245deba00b54c253b432b907c14a3b8d82f36abb199972d400bc'
AND (
token = 'ZL6HK9DX+e1C4BHVW1gn8tnVjyktS4bhvy7a9UoJMR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)