UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tCHwfXCH4XjrETi/Eb6WeXHJztA9LIhko0mif6Q/AYk='
WHERE
key_id = 'c228de251a83d3476a57435e60c397b5cbbe46a9f87f95e2d0e8e1e568d3761a'
AND (
token = 'tCHwfXCH4XjrETi/Eb6WeXHJztA9LIhko0mif6Q/AYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)