UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OptfQtOTAKwgm/U6NVWAuhxDvNCWJKdfEoFm82eAstY='
WHERE
key_id = 'b9a01f6081e6f7b8163dcce4c2a4fab26eecaf851e661db9691cfb91fca8bac1'
AND (
token = 'OptfQtOTAKwgm/U6NVWAuhxDvNCWJKdfEoFm82eAstY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)