UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WjqlERnORCzSDs/GR3zZviQFV/N0992bVXBERfiwST4='
WHERE
key_id = 'd18a4d2f44445d88cb3850235cfb7d10c2d18711546bff972d80fe63047a5f04'
AND (
token = 'WjqlERnORCzSDs/GR3zZviQFV/N0992bVXBERfiwST4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)