UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TUjQdxXt9YvqLYokcb1yHW0PSG+jFtt1vrsvZfRyQ6I='
WHERE
key_id = 'acf4e2e46c759a4d7c34737415e9481e4d7e3baa83e248759902e2cd3b69b88a'
AND (
token = 'TUjQdxXt9YvqLYokcb1yHW0PSG+jFtt1vrsvZfRyQ6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)