UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hmNfW4WGmqxynb7ihZbAXqiOwWoBgWcAIHSVchjKTfc='
WHERE
key_id = '5ba3e5031cda075faeedb9a5f4dc36ac80f3bdd08351e773e7dbc5bb33c2fe09'
AND (
token = 'hmNfW4WGmqxynb7ihZbAXqiOwWoBgWcAIHSVchjKTfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)