UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXbdss0qC8odcJ8HOSj7KXE/3gsOTYY7Fw0soQOzttA='
WHERE
key_id = '2a909f1bb7549c37f69e235b9af9aed02d7988f481d989f62ba566431f747e17'
AND (
token = 'QXbdss0qC8odcJ8HOSj7KXE/3gsOTYY7Fw0soQOzttA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)