UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcHK2ThEHPy9tSzTcjxzCFbA9JlqQdi/YhI8vK+X/Dc='
WHERE
key_id = 'dace9068cb332d2873cf09003b427f1ea8f14bdf29e3589bbda7279d01bb4abf'
AND (
token = 'zcHK2ThEHPy9tSzTcjxzCFbA9JlqQdi/YhI8vK+X/Dc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)