UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ox0eLpqQyCg6ssA/Pc6UCAWO/hUWcjzxq5NRiQXQgo4='
WHERE
key_id = 'b1e895c8b464902fe88b7a8f9658226516050a20e888afd1697b7e45e3d28345'
AND (
token = 'ox0eLpqQyCg6ssA/Pc6UCAWO/hUWcjzxq5NRiQXQgo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)