UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'T9rwK+D3kfGZ7SZIOxeX+7Miaz3h6wFbFTfMQ6kePWM=' 
WHERE 
  key_id = '88533a8c6e1f6c885dd5c5c9b4adf8c9fbb0605ee307384eab15a7b13f5e23ef' 
  AND (
    token = 'T9rwK+D3kfGZ7SZIOxeX+7Miaz3h6wFbFTfMQ6kePWM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039