UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxzmiPlUw2HvX9HSsbsCVmo4ha736o8W5mL/BKzXPas='
WHERE
key_id = '32be8afa52283848ee0bb81a58164492d4b2c1ed28c552e894374826d0462dbc'
AND (
token = 'gxzmiPlUw2HvX9HSsbsCVmo4ha736o8W5mL/BKzXPas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)