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