UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GlGX5Gdp3Z4L5Gg0tmVoZiwjYckmSLKXpDv8I6k5o70='
WHERE
key_id = 'fa9a0efc130559babed41ab0930b3ff8bfc1667d46acef57def0a0ae4bd53fbc'
AND (
token = 'GlGX5Gdp3Z4L5Gg0tmVoZiwjYckmSLKXpDv8I6k5o70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)