UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '28MAgC5SnehaoaBjMYA86jieaO2av5LgUtHNrFdhFzY='
WHERE
key_id = 'a092c70a7220fdf93650f67e3136e0b1c612071097a93e09b77f26c22a7a1dae'
AND (
token = '28MAgC5SnehaoaBjMYA86jieaO2av5LgUtHNrFdhFzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)